Query: Select person that should be match in Blacklist | SDNA

Query: Select person that should be match in Blacklist

Select distinct [BlacklistedAlias].[FirstName] + ‘ ‘ + [BlacklistedAlias].[LastName]From [BlacklistedAlias] Inner Join [Blacklisted] On [BlacklistedAlias].[BlacklistedId] = [Blacklisted].[Id]Where [Blacklisted].[TableNumber] = 17 And ([BlacklistedAlias].[FirstName] + ‘ ‘ + [BlacklistedAlias].[LastName] in (Select [Person].[FirstName] + ‘ ‘ + [Person].[LastName]from [DeMaSy].[DeMaSy].[Person] as [Person] where [Person].[DBId] = XX) or [BlacklistedAlias].[LastName] + ‘ ‘ + [BlacklistedAlias].[FirstName] in (Select [Person].[LastName] + ‘ ‘ + … Continue reading Query: Select person that should be match in Blacklist